USE [GESTION_MORA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0007_DELETE_VALORES_CARGADOS_HOY]    Script Date: 11/23/2011 14:38:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WASP_D0007_DELETE_VALORES_CARGADOS_HOY]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WASP_D0007_DELETE_VALORES_CARGADOS_HOY]
GO

USE [GESTION_MORA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0007_DELETE_VALORES_CARGADOS_HOY]    Script Date: 11/23/2011 14:38:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[WASP_D0007_DELETE_VALORES_CARGADOS_HOY]
AS

BEGIN

SELECT
	CONVERT(VARCHAR(8),GETDATE(),112) AS FECHA

delete  gmhistoricosaldo where 
fecha = getdate()
END
GO

